Accounts Receivable Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblArCashRcptDetail -- AR Cash Receipt Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
RcptDetailID | int | 4 | |||
InvcNum | pInvoiceNum | 15 | |||
PmtAmt | pDecimal | 13 | 0 | ||
Difference | pDecimal | 13 | 0 | ||
PmtAmtFgn | pDecimal | 13 | 0 | ||
DifferenceFgn | pDecimal | 13 | 0 | ||
-*GLAcctGainLoss | pGlAcct | 40 | |||
-*CalcGainLoss | pDecimal | 13 | 0 | ||
RcptHeaderID | int | 4 | 0 | ||
DistCode | pDistCode | 6 | |||
-*InvcExchRate | pDecimal | 13 | -1 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
InvcType | smallint | 2 | Invoice Type | 1 = Invoice, 5 = Pro Forma | |
*OrgInvoiceID | int | 4 | |||
*AdjAmt | pDecimal | 13 | 0 | ||
*AdjAmtFgn | pDecimal | 13 | 0 |
*tblArCashRcptDetailTax -- AR Cash Receipt Detail Tax table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
ID | bigint | 8 | |||
RcptHeaderID | int | 4 | |||
RcptDetailID | int | 4 | |||
TaxLocID | pTaxLoc | ||||
TaxClass | tinyint | 1 | |||
Level | tinyint | 1 | |||
TaxAmt | pDecimal | 13 | |||
TaxAmtFgn | pDecimal | 13 | |||
Taxable | pDecimal | 13 | |||
TaxableFgn | pDecimal | 13 | |||
NonTaxable | pDecimal | 13 | |||
NonTaxableFgn | pDecimal | 13 | |||
LiabilityAcct | pGlAcct | ||||
ExpenseAcct | pGlAcct | ||||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArCashRcptHeader -- AR Cash Receipt Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
RcptHeaderID | int | 4 | |||
DepositID | pBatchID | 6 | '######' | ||
BankID | pBankID | 10 | |||
PmtDate | datetime | 8 | getdate() | ||
PmtAmt | pDecimal | 13 | |||
AgingPd | smallint | 2 | 0 | Appy Receipt to Aging Period | 0 = Oldest, 1 = Unpaid Finance Charge, 2 = 121+Days, 3 = 91-120 Days, 4 = 61-90 Days, 5 = 31-60 Days, 6 = Current |
CheckNum | pCheckNum | 10 | |||
CustId | pCustID | 10 | |||
GLAcct | pGlAcct | 40 | |||
GLPeriod | smallint | 2 | -1 | ||
FiscalYear | smallint | 2 | 0 | ||
PmtMethodId | nvarchar | 10 | |||
CcHolder | nvarchar | 30 | |||
CcNum | nnvarchar | 510 | |||
CcExpire | datetime | 8 | |||
CcAuth | nvarchar | 10 | |||
Note | nvarchar | 25 | |||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
InvcTransID | pTransID | 8 | |||
InvcAppID | nvarchar | 2 | |||
SumHistPeriod | smallint | 2 | 0 | ||
CcSecCode | nvarchar | 6 | |||
BankName | nvarchar | 30 | |||
BankRoutingCode | nvarchar | 9 | |||
BankAcctNum | nnvarchar | 510 | |||
SourceId | uniqueidentifier | 16 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtPmtActivityID | bigint | 8 |
tblArCommIncv -- AR Commission Per Invoice table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
SalesRepID | pSalesRep | 3 | |||
CustId | pCustID | 10 | |||
InvcNum | pInvoiceNum | 15 | |||
InvcDate | datetime | 8 | |||
PctInvc | pDecimal | 13 | 0 | ||
AmtLines | pDecimal | 13 | 0 | ||
AmtTax | pDecimal | 13 | 0 | ||
AmtFreight | pDecimal | 13 | 0 | ||
AmtMisc | pDecimal | 13 | 0 | ||
AmtPmt | pDecimal | 13 | 0 | ||
AmtCogs | pDecimal | 13 | 0 | ||
AmtAdjust | pDecimal | 13 | 0 | ||
AmtPrepared | pDecimal | 13 | 0 | ||
CommPaid | pDecimal | 13 | 0 | ||
CompletedDate | datetime | 8 | |||
HoldYn | bit | 1 | 0 | ||
CommRateDtl | pDecimal | 13 | 0 | ||
PctOfDtl | tinyint | 1 | 0 | Commission Percentage | 0 = None, 1 = Sales(Net), 2 = Gross Profit |
BasedOnDtl | tinyint | 1 | 0 | Commission Basis | 0 = Booked Sales, 1 = Paid Invoices |
PayLines | bit | 1 | -1 | ||
PayTax | bit | 1 | 0 | ||
PayFreight | bit | 1 | 0 | ||
PayMisc | bit | 1 | 0 | ||
AmtInvc | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArCust -- AR Customer table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
CustId | pCustID | 10 | |||
CustName | nvarchar | 30 | |||
Contact | nvarchar | 25 | |||
Addr1 | nvarchar | 30 | |||
Addr2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
ShipZone | nvarchar | 2 | |||
IntlPrefix | nvarchar | 6 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
Attn | nvarchar | 30 | |||
ClassId | nvarchar | 6 | |||
SalesRepId1 | pSalesRep | 3 | |||
SalesRepId2 | pSalesRep | 3 | |||
Rep1PctInvc | pDecimal | 13 | 0 | ||
Rep2PctInvc | pDecimal | 13 | 0 | ||
TermsCode | pTermsCode | 6 | |||
PmtMethod | nvarchar | 10 | |||
GroupCode | nvarchar | 1 | |||
StmtInvcCode | tinyint | 1 | -3 | Document Type | 0 = None, 1 = Statement Only, 2 = Invoice Only, 3 = Both |
AcctType | tinyint | 1 | 0 | Account Type | 0 = Open Invoice, 1 = Balance Forward |
PriceCode | nvarchar | 10 | |||
DistCode | pDistCode | 6 | |||
CalcFinch | bit | 1 | -1 | ||
CreditLimit | pDecimal | 13 | 0 | ||
CreditHold | bit | 1 | 0 | ||
PartialShip | bit | 1 | -1 | ||
AutoCreditHold | bit | 1 | -1 | ||
TaxLocId | pTaxLoc | 10 | |||
Taxable | bit | 1 | -1 | ||
TaxExemptId | nvarchar | 20 | |||
CurrencyId | pCurrency | 6 | |||
TerrId | nvarchar | 10 | |||
CcCompYn | bit | 1 | 0 | ||
CustLevel | nvarchar | 10 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
NewFinch | pDecimal | 13 | 0 | ||
UnpaidFinch | pDecimal | 13 | 0 | ||
CurAmtDue | pDecimal | 13 | 0 | ||
CurAmtDueFgn | pDecimal | 13 | 0 | ||
BalAge1 | pDecimal | 13 | 0 | ||
BalAge2 | pDecimal | 13 | 0 | ||
BalAge3 | pDecimal | 13 | 0 | ||
BalAge4 | pDecimal | 13 | 0 | ||
UnapplCredit | pDecimal | 13 | 0 | ||
FirstSaleDate | datetime | 8 | |||
LastSaleDate | datetime | 8 | |||
LastSaleAmt | pDecimal | 13 | 0 | ||
LastSaleInvc | pInvoiceNum | 15 | |||
LastPayDate | datetime | 8 | |||
LastPayAmt | pDecimal | 13 | 0 | ||
LastPayCheckNum | pCheckNum | 10 | |||
HighBal | pDecimal | 13 | 0 | ||
CreditStatus | nvarchar | 12 | |||
WebDisplInQtyYn | bit | 1 | 0 | ||
Phone1 | nvarchar | 15 | |||
Phone2 | nvarchar | 15 | |||
AllowCharge | bit | 1 | 0 | ||
Status | tinyint | 1 | 0 | Customer Status | 0 = Active, 1 = Inactive |
BillToId | pCustID | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
TaxCertExpDate | datetime | 8 | |||
*TaxPayerType1 | bigint | 8 | |||
*TaxPayerType2 | bigint | 8 | |||
*TaxID1 | nvarchar | 255 | |||
*TaxID2 | nvarchar | 255 | |||
*TaxGrpId2 | pTaxLoc | ||||
*DUNSNumber | nvarchar | 9 |
tblArCustClass -- AR Customer Class table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ClassId | nvarchar | 6 | |||
Desc | nvarchar | 25 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArCustPmtMethod -- AR Customer Payment Method table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | int | 4 | |||
CustId | pCustID | 10 | |||
PmtMethod | nvarchar | 10 | |||
Descr | nvarchar | 30 | |||
CcNum | nnvarchar | 510 | |||
CcName | nvarchar | 30 | |||
CcExpire | datetime | 8 | |||
BankName | nvarchar | 30 | |||
BankRoutingCode | nvarchar | 9 | |||
BankAcctNum | nnvarchar | 510 | |||
MaskValue | nvarchar | 4 | |||
CF | xml | -1 |
tblArDistCode -- AR Distribution Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
DistCode | pDistCode | 6 | |||
Desc | nvarchar | 25 | |||
GLAcctReceivables | pGlAcct | 40 | |||
GLAcctSalesTax | pGlAcct | 40 | |||
GLAcctFreight | pGlAcct | 40 | |||
GLAcctMisc | pGlAcct | 40 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
GLAcctDepositReceivables | pGlAcct | 40 | |||
GLAcctDepositReceivablesContra | pGlAcct | 40 |
tblAFormMsg -- AR Form Message table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
MsgId | nvarchar | 10 | |||
Desc | nvarchar | 50 | |||
ts | timestamp | 8 |
tblArHistAddress -- AR Address History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
CustId | pCustID | 10 | |||
Name | varchar | 30 | |||
Contact | varchar | 25 | |||
Attn | varchar | 30 | |||
Address1 | varchar | 30 | |||
Address2 | varchar | 60 | |||
City | varchar | 30 | |||
Region | varchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | varchar | 10 | |||
Phone | varchar | 15 | |||
Fax | varchar | 15 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
CF | xml | -1 | |||
PostRun | pPostRun | 14 |
tblArHistDeposit -- AR Deposit History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
CustId | pCustID | 10 | |||
InvcNum | pInvoiceNum | 15 | |||
CredMemNum | pInvoiceNum | 15 | |||
Amount | pDecimal | 13 | |||
TermsCode | pTermsCode | 6 | |||
DistCode | pDistCode | 6 | |||
FiscalPeriod | smallint | 2 | |||
FiscalYear | smallint | 2 | |||
CurrencyId | pCurrency | 6 | |||
Description | nvarchar | 30 | |||
ExchRate | pDecimal | 13 | |||
RecType | tinyint | 1 | Record Type | 0 = Invoice, 1 = Credit, 2 = Payment, 3 = Credit Memo | |
Note | nvarchar | max | |||
GLAcctReceivablesDeposit | pGlAcct | 40 | |||
GLAcctReceivablesDepositContra | pGlAcct | 40 | |||
PostDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
Source | tinyint | 1 | Source | 0 = AR, 1 = SO, 2 = SD, 3 = PC | |
SourceId | nvarchar | 510 | |||
ProjectName | nvarchar | 10 | |||
ProjectDescription | nvarchar | 30 | |||
PhaseId | nvarchar | 10 | |||
PhaseDescription | nvarchar | 30 | |||
TaskId | nvarchar | 10 | |||
TaskDescription | nvarchar | 30 | |||
PrintOption | nvarchar | 510 |
tblArHistDetail -- AR Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransID | pTransID | 8 | |||
EntryNum | int | Entry Number | -1 = Sales Tax, -2 = Freight, -3 = Misc | ||
ItemJob | tinyint | 1 | 0 | Item / Job Flag | 0 = Item, 1 = Job |
WhseId | pLocID | 10 | |||
PartId | pItemID | 24 | |||
JobId | nvarchar | 10 | |||
PhaseId | nvarchar | 10 | |||
JobCompleteYN | bit | 1 | 0 | ||
PartType | tinyint | 1 | 0 | Part Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item |
Desc | nvarchar | 35 | |||
AddnlDesc | text | 16 | |||
CatId | nvarchar | 2 | |||
TaxClass | tinyint | 1 | 0 | ||
AcctCode | nvarchar | 6 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctCOGS | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
QtyOrdSell | pDecimal | 13 | 0 | ||
UnitsSell | pUom | 5 | |||
UnitsBase | pUom | 5 | |||
QtyShipSell | pDecimal | 13 | 0 | ||
QtyShipBase | pDecimal | 13 | 0 | ||
QtyBackordSell | pDecimal | 13 | 0 | ||
PriceID | nvarchar | 10 | |||
UnitPriceSell | pDecimal | 13 | 0 | ||
UnitPriceSellFgn | pDecimal | 13 | 0 | ||
UnitCostSell | pDecimal | 13 | 0 | ||
UnitCostSellFgn | pDecimal | 13 | 0 | ||
PriceExt | pDecimal | 13 | 0 | ||
PriceExtFgn | pDecimal | 13 | 0 | ||
CostExtFgn | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
PromoID | nvarchar | 10 | |||
ActShipDate | datetime | 8 | |||
EffectiveRate | pDecimal | 13 | 0 | ||
OrigOrderQty | pDecimal | 13 | 0 | ||
BinNum | nvarchar | 10 | |||
ConversionFactor | pDecimal | 13 | -1 | ||
LottedYN | bit | 1 | 0 | ||
InItemYN | bit | 1 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
ExtCost | pDecimal | 13 | 0 | ||
ExtFinalInc | pDecimal | 13 | 0 | ||
ExtOrigInc | pDecimal | 13 | 0 | ||
TransHistId | nvarchar | 10 | |||
TaskId | nvarchar | 10 | |||
PhaseName | nvarchar | 30 | |||
ProjName | nvarchar | 30 | |||
ExtFinalIncFgn | pDecimal | 13 | 0 | ||
TaskName | nvarchar | 30 | |||
Kit | bit | 1 | 0 | ||
ReqShipDate | datetime | 8 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
UnitCommBasis | pDecimal | 13 | 0 | ||
UnitCommBasisFgn | pDecimal | 13 | 0 | ||
PriceAdjType | tinyint | 1 | 0 | Price Adjustment Type | 0 = Amount, 1 = Percent |
PriceAdjPct | pDecimal | 13 | 0 | ||
PriceAdjAmt | pDecimal | 13 | 0 | ||
PriceAdjAmtFgn | pDecimal | 13 | 0 | ||
UnitPriceSellBasis | pDecimal | 13 | 0 | ||
UnitPriceSellBasisFgn | pDecimal | 13 | 0 | ||
BlanketDtlRef | int | 4 | |||
ZeroPrint | bit | 1 | 0 | ||
LineSeq | int | 4 | |||
BOLNum | varchar | 17 | |||
GrpId | int | 4 | |||
KitQty | pDecimal | 13 | |||
OriCompQty | pDecimal | 13 | 0 | ||
TotQtyOrdSell | pDecimal | 13 | 0 | ||
TotQtyShipSell | pDecimal | 13 | 0 | ||
Status | tinyint | 1 | 0 | Line Item Status | 0 = Open, 1 = Completed |
ResCode | varchar | 10 | |||
DropShipYn | bit | 1 | 0 | ||
CF | xml | -1 | |||
ActivityType | tinyint | 1 | Activity Type | 0 = Time, 1 = Material, 2 = Expense, 3 = Other, 4 = Deposit, 5 = Deposit Applied, 6 = Fixed Fee Billing, 7 = Credit Memo | |
CustomerPartNumber | pDescription | ||||
*ExtLocAID | nvarchar | 10 | |||
*ExtLocBID | nvarchar | 10 | |||
*QtySeqNum_Ext | int | 4 | |||
*QtyStatus | int | 4 |
tblArHistFinch -- AR Finance Charge History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | 0 | ||
CustID | pCustID | 10 | |||
FinchDate | datetime | 8 | |||
FinchAmt | pDecimal | 13 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
FiscalYear | smallint | 2 | 0 | ||
SumHistPeriod | smallint | 2 | -1 | ||
CurrencyID | pCurrency | 6 | |||
FinchAmtFgn | pDecimal | 13 | 0 | ||
ExchRate | pDecimal | 13 | -1 | ||
GLAcctFinch | pGlAcct | 40 | |||
GLAcctReceivables | pGlAcct | 40 | |||
CF | xml | -1 |
tblArHistHeader -- AR Header History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | 0 | ||
TransId | pTransID | 8 | |||
TransType | smallint | 2 | -1 | Transaction Type | 1 = Invoice, -1 = Credit Memo |
BatchId | pBatchID | 6 | '######' | ||
CustId | pCustID | 10 | |||
ShipToID | nvarchar | 10 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
ShipToCity | nvarchar | 30 | |||
ShipToRegion | nvarchar | 10 | |||
ShipToCountry | pCountry | 6 | |||
ShipToPostalCode | nvarchar | 10 | |||
ShipVia | nvarchar | 20 | |||
TermsCode | pTermsCode | 6 | |||
TaxableYN | bit | 1 | -1 | ||
InvcNum | pInvoiceNum | 15 | |||
CredMemNum | pInvoiceNum | 15 | |||
PackNum | pInvoiceNum | 15 | |||
WhseId | pLocID | 10 | |||
OrderDate | datetime | 8 | |||
ShipNum | nvarchar | 18 | |||
ShipDate | datetime | 8 | |||
InvcDate | datetime | 8 | getdate() | ||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
TaxOnFreight | bit | 1 | -1 | ||
TaxClassFreight | tinyint | 1 | 0 | ||
TaxClassMisc | tinyint | 1 | 0 | ||
PostDate | datetime | 8 | |||
FiscalYear | smallint | 2 | |||
GLPeriod | smallint | 2 | |||
TaxGrpID | pTaxLoc | 10 | |||
TaxSubtotal | pDecimal | 13 | 0 | ||
NonTaxSubtotal | pDecimal | 13 | 0 | ||
SalesTax | pDecimal | 13 | 0 | ||
Freight | pDecimal | 13 | 0 | ||
Misc | pDecimal | 13 | 0 | ||
TotCost | pDecimal | 13 | 0 | ||
TotPmtAmt | pDecimal | 13 | 0 | ||
TaxSubtotalFgn | pDecimal | 13 | 0 | ||
NonTaxSubtotalFgn | pDecimal | 13 | 0 | ||
SalesTaxFgn | pDecimal | 13 | 0 | ||
FreightFgn | pDecimal | 13 | 0 | ||
MiscFgn | pDecimal | 13 | 0 | ||
TotCostFgn | pDecimal | 13 | 0 | ||
TotPmtAmtFgn | pDecimal | 13 | 0 | ||
PrintStatus | tinyint | 1 | 0 | Invoice Print Status | 0 = Unprinted, 1=Online, 2 = Batch |
CustPONum | nvarchar | 25 | |||
DistCode | pDistCode | 6 | |||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
CalcGainLoss | pDecimal | 13 | 0 | ||
TotPmtGainLoss | pDecimal | 13 | 0 | ||
DiscDueDate | datetime | 8 | |||
NetDueDate | datetime | 8 | |||
DiscAmt | pDecimal | 13 | 0 | ||
DiscAmtFgn | pDecimal | 13 | 0 | ||
SumHistPeriod | smallint | 2 | -1 | ||
TaxAmtAdj | pDecimal | 13 | 0 | ||
TaxAmtAdjFgn | pDecimal | 13 | 0 | ||
TaxAdj | tinyint | 1 | -1 | ||
TaxLocAdj | nvarchar | 10 | |||
TaxClassAdj | tinyint | 1 | 0 | ||
CustLevel | nvarchar | 10 | |||
PODate | datetime | 8 | |||
ReqShipDate | datetime | 8 | |||
PickNum | nvarchar | 15 | |||
Source | tinyint | 1 | 0 | Source Application | 0 = AR, 1 = SO, 2 = SD, 3 = PC, 4 = PS |
BillingPeriodFrom | datetime | 8 | |||
PMTransType | nvarchar | 4 | |||
ProjItem | nvarchar | 4 | |||
BillingPeriodThru | datetime | 8 | |||
BillingFormat | smallint | 2 | |||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
SoldToId | pCustID | 10 | |||
BlanketRef | int | 4 | |||
CF | xml | -1 | |||
GLAcctFreight | pGlAcct | 40 | |||
GlAcctGainLoss | pGlAcct | 40 | |||
GLAcctMisc | pGlAcct | 40 | |||
GLAcctReceivables | pGlAcct | 40 | |||
GLAcctSalesTax | pGlAcct | 40 | |||
Notes | nvarchar | max | |||
PrintOption | nvarchar | 510 | |||
ReturnDirectToStockYn | bit | 1 | |||
ShipToPhone | varchar | 24 | |||
SourceId | uniqueidentifier | 16 | |||
SourceInfo | varchar | 15 | |||
VoidYn | bit | 1 | 0 | ||
*TaxGrpID2 | pTaxLoc | ||||
*FreightTermID | bigint | ||||
*FreightTerm | nvarchar | 255 | |||
*FreightAccountNumber | nvarchar | 255 | |||
*DeliverySurcharge | bit | 1 | 0 | ||
*ResidentialYN | bit | 1 | 0 | ||
*GlobalLocationNumber | nvarchar | 13 | |||
*TotalCharges | pDecimal | 13 | 0 | ||
*ActualWeight | pDecimal | 13 | 0 | ||
*ShipToFax | nvarchar | 15 | |||
*ShipToEmail | pEmail | ||||
*NumberOfPackage | Int | 4 | |||
*ReqDeliveryDate | datetime | 8 |
tblArHistLot -- AR Lot History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDecimal | 13 | 0 | ||
QtyFilled | pDecimal | 13 | 0 | ||
QtyBkord | pDecimal | 13 | 0 | ||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
EntryNum | int | ||||
*ExtLocAID | nvarchar | 10 | |||
*ExtLocBID | nvarchar | 10 | |||
*QtySeqNum_Ext | int | 4 | |||
*QtyStatus | int | 4 |
tblArHistPmt -- AR Payment History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
PostRun | pPostRun | 14 | 0 | ||
CustId | pCustID | 10 | |||
TransId | pTransID | 8 | |||
InvcNum | pInvoiceNum | 15 | |||
Rep1Id | pSalesRep | 3 | |||
Rep2Id | pSalesRep | 3 | |||
CheckNum | pCheckNum | 10 | |||
CcNum | nnvarchar | 510 | |||
CcHolder | nvarchar | 30 | |||
BankID | pBankID | 10 | |||
DepNum | nvarchar | 25 | |||
DistCode | pDistCode | 6 | |||
PmtMethodId | nvarchar | 10 | |||
CcAuth | nvarchar | 10 | |||
GLRecvAcct | pGlAcct | 40 | |||
PmtDate | datetime | 8 | getdate() | ||
DiffDisc | pDecimal | 13 | 0 | ||
DiffDiscFgn | pDecimal | 13 | 0 | ||
PmtAmt | pDecimal | 13 | 0 | ||
PmtAmtFgn | pDecimal | 13 | 0 | ||
PmtType | tinyint | 1 | -1 | Payment Type | 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = DirectDebit, 7 = External |
GLPeriod | smallint | 2 | 0 | ||
FiscalYear | smallint | 2 | 0 | ||
CurrencyId | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
CalcGainLoss | pDecimal | 13 | 0 | ||
SumHistPeriod | smallint | 2 | -1 | ||
BankName | nvarchar | 30 | |||
BankRoutingCode | nvarchar | 9 | |||
BankAcctNum | nnvarchar | 510 | |||
RecType | tinyint | 1 | 0 | Record Type | 0 = Payment, 1 = Reapplied Credit, 2 = Reapplied Payment, 3 = Prepayment |
CF | xml | -1 | |||
CcExpire | datetime | 8 | |||
GlAcctDebit | pGlAcct | 40 | |||
GlAcctGainLoss | pGlAcct | 40 | |||
Note | varchar | 25 | |||
PostDate | datetime | 8 | |||
RecType | tinyint | 1 | |||
SourceId | uniqueidentifier | 16 | |||
VoidYn | bit | 1 | |||
*AdjAmt | pDecimal | 13 | 0 | ||
*AdjAmtFgn | pDecimal | 13 | 0 |
tblArHistRecur -- AR Recurring Entries History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
Source | tinyint | 1 | 0 | Source | 0 = AR, 1 = SO |
RecurId | nvarchar | 8 | |||
CopyDate | datetime | 8 | |||
BillDate | datetime | 8 | |||
Amount | pDecimal | 13 | 0 | ||
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
UserId | pUserID | 20 | |||
CF | xml | -1 |
tblArHistSer -- AR Serial Number History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
PriceUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
ExtLocAID | varchar | 10 | |||
ExtLocBID | varchar | 10 |
tblArHistTax -- AR Tax History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | 0 | ||
TransId | pTransID | 8 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | 0 | ||
Level | tinyint | 1 | -1 | ||
TaxAmt | pDecimal | 13 | 0 | ||
TaxAmtFgn | pDecimal | 13 | 0 | ||
Taxable | pDecimal | 13 | 0 | ||
TaxableFgn | pDecimal | 13 | 0 | ||
NonTaxable | pDecimal | 13 | 0 | ||
NonTaxableFgn | pDecimal | 13 | 0 | ||
LiabilityAcct | pGlAcct | 40 | |||
CF | xml | -1 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
ExpenseAccount | pGlAcct |
tblArOpenInvoice -- AR Open Invoice table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
CustId | pCustID | 10 | |||
InvcNum | pInvoiceNum | 15 | |||
CredMemNum | pInvoiceNum | 15 | |||
RecType | smallint | 2 | -1 | Invoice Record Type | 1 = Invoice, 4 = Finance Charge, 5 = Pro Forma, -1 = Credit, -2 = Payment, -3 = Gain / Loss |
Status | tinyint | 1 | 0 | Invoice Status | 0 = Rel, 1 = Hold, 4 = Paid |
DistCode | pDistCode | 6 | |||
TermsCode | pTermsCode | 6 | |||
TransDate | datetime | 8 | getdate() | ||
DiscDueDate | datetime | 8 | |||
NetDueDate | datetime | 8 | |||
Amt | pDecimal | 13 | 0 | ||
AmtFgn | pDecimal | 13 | 0 | ||
DiscAmt | pDecimal | 13 | 0 | ||
DiscAmtFgn | pDecimal | 13 | 0 | ||
PmtMethodId | nvarchar | 10 | |||
CheckNum | pCheckNum | 10 | |||
JobId | nvarchar | 10 | |||
CurrencyId | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
GlPeriod | smallint | 2 | 0 | ||
FiscalYear | smallint | 2 | 0 | ||
PhaseId | nvarchar | 10 | |||
ProjId | nvarchar | 10 | |||
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
GainLossStatus | smallint | 2 | 0 | ||
CustPONum | nvarchar | 25 | |||
SourceApp | tinyint | 1 | 0 | Source Application | 0 = AR, 1 = SO, 2 = SD, 3 = PC |
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*AgingPeriod | tinyint | 1 | 0 = Current, 1 = Period1(31-60), 2 = Period2(61-90), 3 = Period3(91-120), 4 = Period4(121+), 10 = FinanceCharge | ||
*InvoiceID | int | 4 | |||
*AppliedAmount | pDecimal | 13 | |||
*AppliedDiscount | pDecimal | 13 | |||
*GainLossAmount | pDecimal | 13 |
tblArPaymentACH -- AR ACH Payment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
BankID | pBankID | 10 | |||
TransmitDate | datetime | 8 | |||
CustID | pCustID | 10 | |||
CustomerName | nvarchar | 30 | |||
CustomerBankName | nvarchar | 30 | |||
CustomerRoutingCode | nvarchar | 9 | |||
CustomerAccountNumber | nnvarchar | 510 | |||
CustomerAcctType | tinyint | 1 | 0 | ||
PaymentAmount | pDecimal | 13 | 0 | ||
PaymentDate | datetime | 8 | |||
PostRun | pPostRun | 14 | |||
TransID | pTransID | 8 | |||
TransactionType | tinyint | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArPmtMethod -- AR Payment Method table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PmtMethodID | nvarchar | 10 | |||
Desc | nvarchar | 30 | |||
PmtType | smallint | 2 | -1 | Payment Type | 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = Direct Debit, 7 = External |
GLAcctDebit | pGlAcct | 40 | |||
BankId | pBankID | 10 | |||
CustId | pCustID | 10 | |||
OpenDrawer | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArPmtMethodDetail -- AR Payment Method Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PmtMethodID | nvarchar | 10 | |||
FiscalYear | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
Pmt | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArRecurDetail -- AR Recurring Entries Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
RecurId | nvarchar | 8 | |||
EntryNum | int | 4 | |||
LineSeq | int | 4 | |||
CatId | nvarchar | 2 | |||
TaxClass | tinyint | 1 | 0 | ||
AcctCode | pGLAcctCode | 2 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctCOGS | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
UnitCommBasis | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
AddnlDescr | nvarchar | max | |||
Descr | varchar | 35 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
PriceId | varchar | 10 | |||
PromoId | varchar | 10 | |||
Quantity | pDecimal | 13 | |||
UnitCost | pDecimal | 13 | |||
UnitPrice | pDecimal | 13 | |||
Units | pUom | 5 | |||
CustomerPartNumber | pDescription |
tblArRecurHeader -- AR Recurring Entries Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
RecurId | nvarchar | 8 | |||
RunCode | nvarchar | 6 | |||
StartingDate | datetime | 8 | |||
EndingDate | datetime | 8 | |||
CurrencyId | pCurrency | 6 | |||
CustId | pCustID | 10 | |||
ShipNum | nvarchar | 18 | |||
ShipVia | nvarchar | 20 | |||
TermsCode | pTermsCode | 6 | |||
DistCode | pDistCode | 6 | |||
TaxableYN | bit | 1 | -1 | ||
CustPoNum | nvarchar | 25 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
TaxClassFreight | tinyint | 1 | 0 | ||
TaxGrpId | pTaxLoc | 10 | |||
TaxClassMisc | tinyint | 1 | 0 | ||
Freight | pDecimal | 13 | 0 | ||
Misc | pDecimal | 13 | 0 | ||
TaxAmtAdj | pDecimal | 13 | 0 | ||
TaxAdj | tinyint | 1 | -1 | ||
TaxLocAdj | pTaxLoc | 10 | |||
TaxClassAdj | tinyint | 1 | 0 | ||
BillType | tinyint | 1 | 0 | Billing Type | 0 = As Needed, 1 = Days, 2 = Monthly, 3 = Quarterly, 4 = Yearly |
BillInterval | int | 4 | 0 | Billing Interval | 0 = Not Set, Non-Zero = Number of Intervals (Days) |
NextBillDate | datetime | 8 | |||
LastBillDate | datetime | 8 | |||
PmtMethodId | nvarchar | 10 | |||
CCNum | nnvarchar | 510 | |||
CCHolder | nvarchar | 30 | |||
CCExpire | datetime | 8 | |||
BankName | nvarchar | 30 | |||
BankAcctNum | nnvarchar | 510 | |||
BankRoutingCode | nvarchar | 9 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
CCAuth | varchar | 10 | |||
CustLevel | varchar | 10 | |||
LocId | pLocID | 10 | |||
PoDate | datetime | 8 | |||
RecurType | tinyint | 1 | Recur Type | 0 = Invoice, 1 = New Order | |
ShipToAddr1 | varchar | 30 | |||
ShipToAddr2 | varchar | 60 | |||
ShipToCity | varchar | 30 | |||
ShipToCountry | pCountry | 6 | |||
ShipToName | varchar | 30 | |||
ShipToPostalCode | varchar | 10 | |||
ShipToRegion | varchar | 10 | |||
SoldToId | pCustID | 10 | |||
ExtPmtActivityID | bigint | 8 | |||
*TaxGrpID2 | pTaxLoc | ||||
*FreightTermID | bigint | ||||
*FreightAccountNumber | nvarchar | 255 | |||
*DeliverySurcharge | bit | 1 | 0 | ||
*ResidentialYN | bit | 1 | 0 | ||
*GlobalLocationNumber | nvarchar | 13 |
tblArSalesAcct -- AR Sales Account table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
AcctCode | pGLAcctCode | 2 | |||
Desc | nvarchar | 35 | |||
GlAcctSales | pGlAcct | 40 | |||
GlAcctCOGS | pGlAcct | 40 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArSalesRep -- AR transaction Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SalesRepID | pSalesRep | 3 | |||
Name | nvarchar | 30 | |||
Addr1 | nvarchar | 30 | |||
Addr2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
IntlPrefix | nvarchar | 6 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
EmplId | pEmpID | 11 | |||
RunCode | nvarchar | 10 | |||
CommRate | pDecimal | 13 | 0 | ||
PctOf | tinyint | 1 | 0 | Commission Percentage | 0 = None, 1 = Sales(Net), 2 = Gross Profit |
BasedOn | tinyint | 1 | 0 | Commission Basis | 0 = Booked Sales, 1 = Paid Invoices |
PayOnLineItems | bit | 1 | -1 | ||
PayOnSalesTax | bit | 1 | 0 | ||
PayOnFreight | bit | 1 | 0 | ||
PayOnMisc | bit | 1 | 0 | ||
PTDSales | pDecimal | 13 | 0 | ||
YTDSales | pDecimal | 13 | 0 | ||
LastSalesDate | datetime | 8 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
PayVia | tinyint | 1 | 0 | Pay Via | 0 = None, 1 = Payroll, 2 = Accounts Payable |
EarnCode | pCode | 3 | |||
VendorId | pVendorID | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArSalesRepComm -- AR Sales Rep Commission table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | int | 4 | |||
SalesRepID | pSalesRep | 3 | |||
CommType | tinyint | 1 | 0 | Commission Type | 0 = Item ID, 1 = Product Line, 2 = Category |
RefID | nvarchar | 24 | |||
CommRate | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArShipMethod -- AR Ship Method table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ShipMethodID | nvarchar | 6 | |||
Desc | nvarchar | 20 | |||
OnlineTrackYn | bit | 1 | 0 | ||
InternetPath | nvarchar | 255 | |||
HoldingCharacters | nvarchar | 10 | |||
Additional1 | nvarchar | 50 | |||
Additional2 | nvarchar | 50 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ShipperID | bigint | 8 | |||
*MaxContainerValue | pDecimal | 13 | |||
*MaxContainerWeight | pDecimal | 13 | |||
*MaxShipValue | pDecimal | 13 | |||
*MaxShipWeight | pDecimal | 13 |
tblArShipTo -- AR Ship To table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
CustId | pCustID | 10 | |||
ShiptoId | pCustID | 10 | |||
ShiptoName | nvarchar | 30 | |||
Addr1 | nvarchar | 30 | |||
Addr2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
IntlPrefix | nvarchar | 6 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
Attn | nvarchar | 30 | |||
ShipVia | nvarchar | 20 | |||
TaxLocID | pTaxLoc | 10 | |||
TerrId | nvarchar | 10 | |||
DistCode | pDistCode | 6 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
AddressType | tinyint | 1 | 0 | Address Type | 0 = Business, 1 = Residential |
Phone1 | nvarchar | 15 | |||
Phone2 | nvarchar | 15 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*TaxGrpId2 | pTaxLoc | ||||
*FreightTermID | bigint | 8 | |||
*FreightAccountNumber | nvarchar | 255 | |||
*DeliverySurcharge | bit | 1 | 0 | ||
*ResidentialYN | bit | 1 | 0 | ||
*GlobalLocationNumber | nvarchar | 13 |
tblArTermsCode -- AR Terms Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TermsCode | pTermsCode | 6 | |||
Desc | nvarchar | 15 | |||
DiscPct | pDecimal | 13 | 0 | ||
DiscDayOfMonth | bit | 1 | 0 | Discount Day of Month Yes / No Flag | 0 = No, -1 = Yes |
DiscDays | smallint | 2 | 0 | ||
DiscMinDays | smallint | 2 | 0 | ||
NetDueDays | smallint | 2 | 0 | ||
NetDueDayOfMonth | bit | 1 | 0 | ||
NetDueMinDays | smallint | 2 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblArTransDetail -- AR Transaction Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
ItemJob | tinyint | 1 | 0 | Item / Job Flag | 0 = Item, 1 = Job |
WhseId | pLocID | 10 | |||
PartId | pItemID | 24 | |||
JobId | nvarchar | 10 | |||
PhaseId | nvarchar | 10 | |||
JobCompleteYN | bit | 1 | 0 | ||
EntryNum | int | ||||
Desc | nvarchar | 35 | |||
LottedYn | bit | 1 | 0 | ||
PartType | tinyint | 1 | 0 | Part Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 4 = Job |
AddnlDesc | text | 16 | |||
CatId | nvarchar | 2 | |||
TaxClass | tinyint | 1 | 0 | ||
AcctCode | pGLAcctCode | 2 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctCOGS | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
QtyOrdSell | pDecimal | 13 | 0 | ||
UnitsSell | pUom | 5 | |||
UnitsBase | pUom | 5 | |||
QtyShipBase | pDecimal | 13 | 0 | ||
QtyShipSell | pDecimal | 13 | 0 | ||
QtyBackordSell | pDecimal | 13 | 0 | ||
PriceCode | nvarchar | 10 | |||
UnitPriceSell | pDecimal | 13 | 0 | ||
UnitCostSell | pDecimal | 13 | 0 | ||
UnitPriceSellFgn | pDecimal | 13 | 0 | ||
UnitCostSellFgn | pDecimal | 13 | 0 | ||
PriceExt | pDecimal | 13 | 0 | ||
PriceExtFgn | pDecimal | 13 | 0 | ||
CostExtFgn | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
ExtCost | pDecimal | 13 | 0 | ||
ExtFinalInc | pDecimal | 13 | 0 | ||
ExtOrigInc | pDecimal | 13 | 0 | ||
TransHistId | nvarchar | 10 | |||
TaskId | nvarchar | 10 | |||
PhaseName | nvarchar | 30 | |||
ProjName | nvarchar | 30 | |||
ExtFinalIncFgn | pDecimal | 13 | 0 | ||
TaskName | nvarchar | 30 | |||
QtySeqNum | int | 4 | 0 | ||
ReqShipDate | datetime | 8 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
UnitCommBasis | pDecimal | 13 | 0 | ||
UnitCommBasisFgn | pDecimal | 13 | 0 | ||
PriceAdjType | tinyint | 1 | 0 | Price Adjustment Type | 0 = Amount, 1 = Percent |
PriceAdjPct | pDecimal | 13 | 0 | ||
PriceAdjAmt | pDecimal | 13 | 0 | ||
PriceAdjAmtFgn | pDecimal | 13 | 0 | ||
UnitPriceSellBasis | pDecimal | 13 | 0 | ||
UnitPriceSellBasisFgn | pDecimal | 13 | 0 | ||
ZeroPrint | bit | 1 | 0 | ||
LineSeq | int | 4 | |||
CustomerPartNumber | pDescription | ||||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocA | int | 4 | |||
*ExtLocB | int | 4 | |||
*QtySeqNum_Ext | int | 4 | |||
*QtyStatus | int | 4 |
tblArTransHeader -- AR Transaction Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
TransType | smallint | 2 | -1 | Transaction Type | 1 = Invoice, -1 = Credit Memo |
VoidYn | bit | 1 | 0 | ||
BatchId | pBatchID | 6 | '######' | ||
CustId | pCustID | 10 | |||
ShipToID | pCustID | 10 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
ShipToCity | nvarchar | 30 | |||
ShipToRegion | nvarchar | 10 | |||
ShipToCountry | pCountry | 6 | |||
ShipToPostalCode | nvarchar | 10 | |||
ShipVia | nvarchar | 20 | |||
TermsCode | pTermsCode | 6 | |||
TaxableYN | bit | 1 | -1 | ||
InvcNum | pInvoiceNum | 15 | |||
OrgInvcNum | pInvoiceNum | 15 | |||
-*OrgInvcExchRate | pDecimal | 13 | -1 | ||
WhseId | pLocID | 10 | |||
OrderDate | datetime | 8 | |||
ShipNum | nvarchar | 18 | |||
ShipDate | datetime | 8 | |||
InvcDate | datetime | 8 | getdate() | ||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
TaxOnFreight | bit | 1 | -1 | ||
TaxClassFreight | tinyint | 1 | 0 | ||
TaxClassMisc | tinyint | 1 | 0 | ||
PostDate | datetime | 8 | |||
GLPeriod | smallint | 2 | 0 | ||
FiscalYear | smallint | 2 | 0 | ||
TaxGrpID | pTaxLoc | 10 | |||
TaxSubtotal | pDecimal | 13 | 0 | ||
NonTaxSubtotal | pDecimal | 13 | 0 | ||
SalesTax | pDecimal | 13 | 0 | ||
Freight | pDecimal | 13 | 0 | ||
Misc | pDecimal | 13 | 0 | ||
TotCost | pDecimal | 13 | 0 | ||
TaxSubtotalFgn | pDecimal | 13 | 0 | ||
NonTaxSubtotalFgn | pDecimal | 13 | 0 | ||
SalesTaxFgn | pDecimal | 13 | 0 | ||
FreightFgn | pDecimal | 13 | 0 | ||
MiscFgn | pDecimal | 13 | 0 | ||
TotCostFgn | pDecimal | 13 | 0 | ||
PrintStatus | tinyint | 1 | 0 | Invoice Print Status | 0 = Unprinted, 1=Online, 2 = Batch |
CustPONum | nvarchar | 25 | |||
DistCode | pDistCode | 6 | |||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
-*CalcGainLoss | pDecimal | 13 | 0 | ||
DiscDueDate | datetime | 8 | |||
NetDueDate | datetime | 8 | |||
DiscAmt | pDecimal | 13 | 0 | ||
DiscAmtFgn | pDecimal | 13 | 0 | ||
-*SumHistPeriod | smallint | 2 | -1 | ||
TaxAmtAdj | pDecimal | 13 | 0 | ||
TaxAmtAdjFgn | pDecimal | 13 | 0 | ||
TaxAdj | tinyint | 1 | -1 | ||
TaxLocAdj | pTaxLoc | 10 | |||
TaxClassAdj | tinyint | 1 | 0 | ||
-*BillingPeriodFrom | datetime | 8 | |||
-*PMTransType | nvarchar | 4 | |||
-*ProjItem | nvarchar | 4 | Item Detail / No Detail / Project Detail Flag | IT = Item, NO = Unassigned, PR = Project | |
-*BillingPeriodThru | datetime | 8 | |||
-*BillingFormat | smallint | 2 | |||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
-*CRFromHist | bit | 1 | 0 | ||
SourceId | uniqueidentifier | 16 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*OrgInvoiceID | int | 4 | |||
*TaxGrpID2 | pTaxLoc |
tblArTransLot -- AR Lot Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDecimal | 13 | 0 | ||
QtyFilled | pDecimal | 13 | 0 | ||
QtyBkord | pDecimal | 13 | 0 | ||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocA | int | 4 | |||
*ExtLocB | int | 4 | |||
*QtySeqNum_Ext | int | 4 | |||
*QtyStatus | int | 4 |
tblArTransPmt -- AR Transaction Payment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BankAcctNum | nvarchar | 510 | |||
BankName | varchar | 30 | |||
BankRoutingCode | varchar | 9 | |||
CalcGainLoss | pDecimal | 13 | |||
CcAuth | varchar | 10 | |||
CcExpire | datetime | 8 | |||
CcHolder | varchar | 30 | |||
CcNum | nvarchar | 510 | |||
CcSecCode | varchar | 6 | |||
CheckNum | pCheckNum | 10 | |||
CurrencyId | pCurrency | 6 | |||
DepositId | pBatchID | 6 | |||
ExchRate | pDecimal | 13 | |||
FiscalYear | smallint | 2 | |||
GlAcctGainLoss | pGlAcct | 40 | |||
GlAcctReceivables | pGlAcct | 40 | |||
GlPeriod | smallint | 2 | |||
LinkId | int | 4 | |||
Note | varchar | 25 | |||
PmtAmt | pDecimal | 13 | |||
PmtAmtFgn | pDecimal | 13 | |||
PmtDate | datetime | 8 | |||
PmtMethodId | varchar | 10 | |||
PmtNum | int | 4 | |||
PostedYn | bit | 1 | |||
TransId | pTransID | 8 | |||
ts | timestamp | 8 | |||
CF | xml | -1 | |||
ExtPmtActivityID | bigint | 8 |
tblArTransSer -- AR Serial Number Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
EntryNum | int | ||||
TransId | pTransID | 8 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
PriceUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
*CostUnitACV | pDecimal | 13 |
tblArTransTax -- AR Tax Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | 0 | ||
Level | tinyint | 1 | -1 | ||
TaxAmt | pDecimal | 13 | 0 | ||
TaxAmtFgn | pDecimal | 13 | 0 | ||
Taxable | pDecimal | 13 | 0 | ||
TaxableFgn | pDecimal | 13 | 0 | ||
NonTaxable | pDecimal | 13 | 0 | ||
NonTaxableFgn | pDecimal | 13 | 0 | ||
LiabilityAcct | pGlAcct | 40 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
ExpenseAccount | pGlAcct |